package com.bw.gmallapi.mapper;

import com.bw.gmallapi.pojo.Order;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

@Mapper
public interface OrderMapper {
    @Select("select sum(price) from H where date=#{date}")
    BigDecimal getGmv(String date);

    @Select("select id,price,date from H ")
    List<Order> getOrderList(String date);
}
